# -*- coding: utf-8 -*-
# @Time : 2021/5/17 19:32
# @Author : ShaneGao
# @File : load.py
# @Software: PyCharm
import pandas as pd

def load_runoff(filepath='./data_set/huaxian.xlsx'):
    df = pd.read_excel(filepath, header=0, parse_dates=[0], index_col=0)
    series=pd.Series(df.values.flatten())
    series.index=pd.date_range(start='1954-1',end='2017-1',freq='M').to_period()
    series.index=[series.index.values[i].__str__() for i in range(len(series.index.values))]
    return series

#load_runoff().to_excel('径流数据.xlsx')